﻿CREATE TABLE [flcr].[ENVIRONMENT] (
    [ENV_ID]            INT           IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]        VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]        DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]     INT           NOT NULL,
    [AUDIT_MOD_USER]    VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]    DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ] INT           NOT NULL,
    [BUILTIN]           BIT           NOT NULL,
    [WRKFL_ITEM_ID]     INT           NOT NULL,
    [WRKFL_STATUS_ID]   INT           NOT NULL,
    [ACTIVE_FLG]        BIT           NOT NULL,
    [SORT_ORDER]        INT           NOT NULL,
    [ENV_NAME]          VARCHAR (100) NOT NULL,
    [ENV_SNAME]         VARCHAR (50)  NOT NULL,
    [ENV_DESC]          VARCHAR (MAX) NOT NULL,
    [ENV_TYPE]          INT           NOT NULL,
    [PROCESS_ORDER]     INT           NOT NULL,
    [PARENT_ID]         INT           NULL,
    [ENV_CAT_ID]        INT           NOT NULL
);

